-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE AddTimetable
	-- Add the parameters for the stored procedure here
	@no numeric(3,0), 
	@name nvarchar(20), 
	@exFrom numeric (8,0), 
	@exTo numeric (8,0), 
	@abbr nvarchar(20), 
	@workFrom numeric(4,0),
	@workTo numeric(4,0),
	@delim numeric(4,0), 
	@unit numeric(2,0), 
	@otUnit numeric(2,0),
	@status numeric(1,0), 
	@createDate datetime, 
	@updateDate datetime
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    INSERT INTO TIME_TABLE(TIME_TABLE_NO, TIME_TABLE_NAME, EXPIRATION_FROM,EXPIRATION_TO,
							ABREVIATION, WORK_FROM, WORK_TO, DELIMITATION, UNIT_MINUTES, 
							OVER_UNIT_MINUTES, [STATUS], CREATE_DATE_TIME, UPDATE_DATE_TIME_TABLE)
	VALUES (@no, @name, @exFrom, @exTo, @abbr, @workFrom, @workTo, @delim, @unit, @otUnit, @status, @createDate, @updateDate)
END
GO
